JDBC Handler
The standard handler name for JDBC is JDBC. Here is an example:
< DBHandler:JDBC >
Install = JDBW32->JDBInstallHandler
Or
InstallMod= JDBW32
InstallFunc= JDBInstallHandler
The Install option specifies the DLL module name and handler function name. This function is linked dynamically when the handler is initialized. Actually, the above definitions are not necessary for JDBC support. The database library will default the module and function name to the values shown. When defining a JDBC connection, the connection information may be provided either the INI file or in a ODEE .bindings file. When the information is provided in the INI file, the INI section must contain the Server, User, and PassWd entries. If the connection information is provided in the .bindings file, then the section in the INI file provides the location of the .bindings file information.
When all of the information is in the INI file, the INI section must have the following entries:
Server = Server name (default is “MS SQL Server”)
The Server option is used to provide the URL for connecting to the database. The format of the URL is specific to the database driver, but typically will identify the driver class, driver type, database host address, port number on the database, and database name. There is no default value.
User= User ID (no default)
PassWd= User password(no default)
User and Passwd options are required. They provide a way to automatically log on to the database.
When the connection information is provided in the .bindings file, then the INI section must contain the following two entries:
JNDIContext= The directory where the .bindings file is located. Note that this should not included the .bindings file name ( “C:\context”, not “C:\context\.bindings”).
JNDIName=The name of the section in the .bindings file that contains the connection information.
In addition to the connection information, the following optional values may appear in the INI section:
CreateIndex=Yes / No(default is Yest
CreateTable=Yes / No(default is Yes)
The CreateTable and CreateIndex options can be used to prevent time delay while a table is checked for existence. In this way, the normal capabilities of the connected driver may be overridden. When set to No, any attempt to open the file with a mode of CREATE_IF_NEW will automatically be rejected. Some drivers may not support creating a table or index, and may require these options to be set to No.